package com.example.demo.dao;

import com.example.demo.dto.RankDto;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author ZhengWei
 * @Description
 * @date 2020/7/20 9:15 上午
 */
@Repository
public interface RankDao {
    
    @Select("SELECT rank.*,sku.tags AS skuTags,sku.description AS skuDescription " +
            "FROM dzdp_rank rank,dzdp_sku sku " +
            "WHERE rank.cityid = #{cityId} " +
            "AND rank.skuid = #{skuId} " +
            "AND rank.skuid = sku.skuid " +
            "ORDER BY rank")
    List<RankDto> getRankList(Integer cityId, Integer skuId);
}
